CREATE FUNCTION [dbo].[GetValueListTable] (@ListValues varchar(5000))  
RETURNS @valTable TABLE (uid varchar(10)) AS  
BEGIN
    
    DECLARE @ListValueID varchar(10), @Pos int

    SET @ListValues = LTRIM(RTRIM(@ListValues))+ ','
        SET @Pos = CHARINDEX(',', @ListValues, 1)
    
        IF REPLACE(@ListValues, ',', '') <> ''
        BEGIN
            WHILE @Pos > 0
            BEGIN
                SET @ListValueID = LTRIM(RTRIM(LEFT(@ListValues, @Pos - 1)))
                IF @ListValueID <> ''
                BEGIN
                    INSERT INTO @valTable (uid) VALUES (@ListValueID) --Use Appropriate conversion
                END
                SET @ListValues = RIGHT(@ListValues, LEN(@ListValues) - @Pos)
                SET @Pos = CHARINDEX(',', @ListValues, 1)
    
            END
        END        

    RETURN
END

GO